In [ ]:
#STOCK_PRICE_ANALYSIS
In [80]:
#In this project,We will use stock data of 505 companies and select a few big tech companies and perform various types of analysis on them
In [ ]:
#EXTRACTING THE DATA
In [30]:
import pandas as pd
import numpy as np
import matplotlib.pyplot as plt
import seaborn as sns
In [31]:
import glob
In [ ]:
#We are using glob module to import csv files of stock prices from the path where we have saved the files
In [34]:
glob.glob(r'D:\DA Projects\Stock_Price_Analysis\individual_stocks_5yr/*csv')
Out[34]:
['D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\AAL_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\AAPL_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\AAP_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\ABBV_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\ABC_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\ABT_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\ACN_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\ADBE_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\ADI_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\ADM_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\ADP_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\ADSK_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\ADS_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\AEE_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\AEP_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\AES_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\AET_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\AFL_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\AGN_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\AIG_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\AIV_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\AIZ_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\AJG_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\AKAM_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\ALB_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\ALGN_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\ALK_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\ALLE_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\ALL_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\ALXN_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\AMAT_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\AMD_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\AME_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\AMGN_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\AMG_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\AMP_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\AMT_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\AMZN_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\ANDV_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\ANSS_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\ANTM_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\AON_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\AOS_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\APA_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\APC_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\APD_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\APH_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\APTV_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\ARE_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\ARNC_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\ATVI_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\AVB_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\AVGO_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\AVY_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\AWK_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\AXP_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\AYI_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\AZO_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\A_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\BAC_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\BAX_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\BA_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\BBT_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\BBY_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\BDX_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\BEN_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\BF.B_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\BHF_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\BHGE_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\BIIB_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\BK_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\BLK_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\BLL_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\BMY_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\BRK.B_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\BSX_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\BWA_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\BXP_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\CAG_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\CAH_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\CAT_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\CA_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\CBG_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\CBOE_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\CBS_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\CB_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\CCI_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\CCL_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\CDNS_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\CELG_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\CERN_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\CFG_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\CF_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\CHD_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\CHK_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\CHRW_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\CHTR_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\CINF_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\CI_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\CLX_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\CL_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\CMA_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\CMCSA_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\CME_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\CMG_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\CMI_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\CMS_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\CNC_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\CNP_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\COF_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\COG_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\COL_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\COO_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\COP_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\COST_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\COTY_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\CPB_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\CRM_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\CSCO_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\CSRA_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\CSX_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\CTAS_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\CTL_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\CTSH_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\CTXS_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\CVS_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\CVX_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\CXO_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\C_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\DAL_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\DE_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\DFS_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\DGX_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\DG_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\DHI_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\DHR_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\DISCA_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\DISCK_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\DISH_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\DIS_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\DLR_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\DLTR_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\DOV_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\DPS_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\DRE_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\DRI_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\DTE_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\DUK_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\DVA_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\DVN_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\DWDP_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\DXC_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\D_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\EA_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\EBAY_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\ECL_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\ED_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\EFX_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\EIX_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\EL_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\EMN_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\EMR_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\EOG_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\EQIX_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\EQR_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\EQT_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\ESRX_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\ESS_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\ES_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\ETFC_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\ETN_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\ETR_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\EVHC_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\EW_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\EXC_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\EXPD_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\EXPE_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\EXR_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\FAST_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\FBHS_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\FB_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\FCX_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\FDX_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\FE_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\FFIV_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\FISV_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\FIS_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\FITB_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\FLIR_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\FLR_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\FLS_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\FL_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\FMC_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\FOXA_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\FOX_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\FRT_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\FTI_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\FTV_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\F_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\GD_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\GE_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\GGP_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\GILD_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\GIS_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\GLW_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\GM_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\GOOGL_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\GOOG_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\GPC_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\GPN_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\GPS_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\GRMN_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\GS_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\GT_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\GWW_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\HAL_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\HAS_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\HBAN_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\HBI_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\HCA_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\HCN_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\HCP_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\HD_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\HES_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\HIG_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\HII_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\HLT_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\HOG_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\HOLX_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\HON_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\HPE_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\HPQ_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\HP_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\HRB_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\HRL_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\HRS_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\HSIC_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\HST_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\HSY_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\HUM_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\IBM_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\ICE_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\IDXX_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\IFF_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\ILMN_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\INCY_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\INFO_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\INTC_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\INTU_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\IPG_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\IP_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\IQV_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\IRM_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\IR_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\ISRG_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\ITW_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\IT_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\IVZ_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\JBHT_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\JCI_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\JEC_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\JNJ_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\JNPR_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\JPM_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\JWN_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\KEY_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\KHC_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\KIM_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\KLAC_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\KMB_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\KMI_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\KMX_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\KORS_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\KO_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\KR_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\KSS_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\KSU_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\K_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\LB_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\LEG_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\LEN_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\LH_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\LKQ_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\LLL_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\LLY_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\LMT_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\LNC_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\LNT_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\LOW_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\LRCX_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\LUK_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\LUV_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\LYB_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\L_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\MAA_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\MAC_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\MAR_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\MAS_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\MAT_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\MA_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\MCD_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\MCHP_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\MCK_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\MCO_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\MDLZ_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\MDT_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\MET_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\MGM_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\MHK_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\MKC_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\MLM_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\MMC_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\MMM_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\MNST_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\MON_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\MOS_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\MO_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\MPC_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\MRK_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\MRO_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\MSFT_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\MSI_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\MS_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\MTB_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\MTD_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\MU_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\MYL_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\M_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\NAVI_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\NBL_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\NCLH_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\NDAQ_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\NEE_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\NEM_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\NFLX_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\NFX_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\NI_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\NKE_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\NLSN_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\NOC_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\NOV_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\NRG_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\NSC_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\NTAP_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\NTRS_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\NUE_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\NVDA_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\NWL_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\NWSA_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\NWS_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\OKE_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\OMC_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\ORCL_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\ORLY_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\OXY_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\O_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\PAYX_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\PBCT_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\PCAR_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\PCG_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\PCLN_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\PDCO_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\PEG_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\PEP_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\PFE_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\PFG_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\PGR_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\PG_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\PHM_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\PH_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\PKG_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\PKI_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\PLD_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\PM_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\PNC_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\PNR_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\PNW_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\PPG_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\PPL_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\PRGO_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\PRU_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\PSA_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\PSX_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\PVH_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\PWR_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\PXD_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\PX_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\PYPL_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\QCOM_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\QRVO_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\RCL_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\REGN_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\REG_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\RE_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\RF_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\RHI_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\RHT_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\RJF_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\RL_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\RMD_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\ROK_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\ROP_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\ROST_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\RRC_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\RSG_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\RTN_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\SBAC_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\SBUX_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\SCG_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\SCHW_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\SEE_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\SHW_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\SIG_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\SJM_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\SLB_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\SLG_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\SNA_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\SNI_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\SNPS_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\SO_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\SPGI_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\SPG_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\SRCL_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\SRE_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\STI_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\STT_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\STX_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\STZ_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\SWKS_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\SWK_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\SYF_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\SYK_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\SYMC_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\SYY_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\TAP_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\TDG_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\TEL_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\TGT_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\TIF_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\TJX_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\TMK_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\TMO_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\TPR_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\TRIP_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\TROW_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\TRV_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\TSCO_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\TSN_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\TSS_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\TWX_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\TXN_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\TXT_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\T_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\UAA_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\UAL_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\UA_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\UDR_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\UHS_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\ULTA_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\UNH_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\UNM_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\UNP_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\UPS_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\URI_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\USB_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\UTX_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\VAR_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\VFC_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\VIAB_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\VLO_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\VMC_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\VNO_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\VRSK_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\VRSN_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\VRTX_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\VTR_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\VZ_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\V_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\WAT_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\WBA_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\WDC_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\WEC_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\WFC_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\WHR_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\WLTW_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\WMB_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\WMT_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\WM_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\WRK_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\WU_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\WYNN_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\WYN_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\WY_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\XEC_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\XEL_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\XLNX_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\XL_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\XOM_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\XRAY_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\XRX_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\XYL_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\YUM_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\ZBH_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\ZION_data.csv',
 'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\ZTS_data.csv']
In [35]:
len(glob.glob(r'D:\DA Projects\Stock_Price_Analysis\individual_stocks_5yr/*csv')) #Finding total number of stocks
Out[35]:
505
In [36]:
#We are analysing the stocks of Facebook, Apple, Microsoft & Google for this project. So lets save the data of these companies.
In [62]:
company_list =[
    r'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\AAPL_data.csv',
    r'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\FB_data.csv',
    r'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\GOOG_data.csv',
    r'D:\\DA Projects\\Stock_Price_Analysis\\individual_stocks_5yr\\MSFT_data.csv',
]
In [63]:
#using warnings package to filter out future warnings
import warnings
from warnings import filterwarnings
filterwarnings('ignore')
In [64]:
all_data = pd.DataFrame()

for file in company_list:
    
    current_df = pd.read_csv(file)
    
    all_data = pd.concat([current_df, all_data], ignore_index=True)
In [65]:
all_data.shape ## dimensions of all_data dataframe ..
Out[65]:
(4752, 7)
In [66]:
all_data.head(6)
Out[66]:
date open high low close volume Name
0 2013-02-08 27.35 27.71 27.310 27.55 33318306 MSFT
1 2013-02-11 27.65 27.92 27.500 27.86 32247549 MSFT
2 2013-02-12 27.88 28.00 27.750 27.88 35990829 MSFT
3 2013-02-13 27.93 28.11 27.880 28.03 41715530 MSFT
4 2013-02-14 27.92 28.06 27.870 28.04 32663174 MSFT
5 2013-02-15 28.04 28.16 27.875 28.01 49650538 MSFT
In [67]:
all_data['Name'].unique()
Out[67]:
array(['MSFT', 'GOOG', 'FB', 'AAPL'], dtype=object)
In [ ]:
In [ ]:
#CLEANING AND ANALYSING CHANGE IN STOCK PRICE OVER TIME
In [ ]:
In [69]:
all_data.isnull().sum() #After extracting the data, we are cleansing it, we start off by Checking for missing data
Out[69]:
date      0
open      0
high      0
low       0
close     0
volume    0
Name      0
dtype: int64
In [70]:
#Thankfully, we have no missing data, lets proceed to check if the data types are in order
In [71]:
all_data.dtypes
Out[71]:
date       object
open      float64
high      float64
low       float64
close     float64
volume      int64
Name       object
dtype: object
In [ ]:
#We cant use this format of data as object. We need to convert it to datetime format.
In [73]:
all_data['date'] = pd.to_datetime(all_data['date']) ## converting data-type of "date" featuer into date-time ..
In [74]:
all_data['date']
Out[74]:
0      2013-02-08
1      2013-02-11
2      2013-02-12
3      2013-02-13
4      2013-02-14
          ...    
4747   2018-02-01
4748   2018-02-02
4749   2018-02-05
4750   2018-02-06
4751   2018-02-07
Name: date, Length: 4752, dtype: datetime64[ns]
In [75]:
all_data.dtypes
Out[75]:
date      datetime64[ns]
open             float64
high             float64
low              float64
close            float64
volume             int64
Name              object
dtype: object
In [76]:
#We have successfully changed the format
In [77]:
tech_list = all_data['Name'].unique() #Storing company names into a variable
In [78]:
tech_list
Out[78]:
array(['MSFT', 'GOOG', 'FB', 'AAPL'], dtype=object)
In [84]:
plt.figure(figsize=(20,9))

for index , company in enumerate(tech_list , 1):
    plt.subplot(2 , 2 , index) ## creating subplot for each stock
    filter1 = all_data['Name']==company
    df = all_data[filter1]
    plt.plot(df['date'] , df['close']) ## plotting "date" vs "close"
    plt.title(company)
In [ ]:
In [85]:
#Analyzing Moving Average of various stocks
In [86]:
all_data.head(15)
Out[86]:
date open high low close volume Name
0 2013-02-08 27.3500 27.71 27.310 27.550 33318306 MSFT
1 2013-02-11 27.6500 27.92 27.500 27.860 32247549 MSFT
2 2013-02-12 27.8800 28.00 27.750 27.880 35990829 MSFT
3 2013-02-13 27.9300 28.11 27.880 28.030 41715530 MSFT
4 2013-02-14 27.9200 28.06 27.870 28.040 32663174 MSFT
5 2013-02-15 28.0400 28.16 27.875 28.010 49650538 MSFT
6 2013-02-19 27.8801 28.09 27.800 28.045 38804616 MSFT
7 2013-02-20 28.1300 28.20 27.830 27.870 44109412 MSFT
8 2013-02-21 27.7400 27.74 27.230 27.490 49078338 MSFT
9 2013-02-22 27.6800 27.76 27.480 27.760 31425726 MSFT
10 2013-02-25 27.9700 28.05 27.370 27.370 48011248 MSFT
11 2013-02-26 27.3800 27.60 27.340 27.370 49917353 MSFT
12 2013-02-27 27.4200 28.00 27.330 27.810 36390889 MSFT
13 2013-02-28 27.8800 27.97 27.740 27.800 35836861 MSFT
14 2013-03-01 27.7200 27.98 27.520 27.950 34849287 MSFT
In [87]:
all_data['close'].rolling(window=10).mean().head(14)
Out[87]:
0         NaN
1         NaN
2         NaN
3         NaN
4         NaN
5         NaN
6         NaN
7         NaN
8         NaN
9     27.8535
10    27.8355
11    27.7865
12    27.7795
13    27.7565
Name: close, dtype: float64
In [89]:
new_data = all_data.copy()
In [90]:
#### now lets consider different windows of rolling ,ie 10 days ,20 days ,30 days 
ma_day = [10 ,20 , 50]

for ma in ma_day:
    new_data['close_'+str(ma)] = new_data['close'].rolling(ma).mean()
In [91]:
new_data.tail(7)
Out[91]:
date open high low close volume Name close_10 close_20 close_50
4745 2018-01-30 165.525 167.3700 164.7000 166.97 46048185 AAPL 174.263 174.3340 172.9460
4746 2018-01-31 166.870 168.4417 166.5000 167.43 32478930 AAPL 173.096 174.0925 172.8726
4747 2018-02-01 167.165 168.6200 166.7600 167.78 47230787 AAPL 171.948 173.8700 172.8252
4748 2018-02-02 166.000 166.8000 160.1000 160.50 86593825 AAPL 170.152 173.2435 172.6356
4749 2018-02-05 159.100 163.8800 156.0000 156.49 72738522 AAPL 168.101 172.3180 172.3026
4750 2018-02-06 154.830 163.7200 154.0000 163.03 68243838 AAPL 166.700 171.7520 172.0640
4751 2018-02-07 163.085 163.4000 159.0685 159.54 51608580 AAPL 165.232 171.0125 171.7554
In [92]:
new_data.set_index('date' , inplace=True)
In [93]:
new_data
Out[93]:
open high low close volume Name close_10 close_20 close_50
date
2013-02-08 27.350 27.71 27.3100 27.55 33318306 MSFT NaN NaN NaN
2013-02-11 27.650 27.92 27.5000 27.86 32247549 MSFT NaN NaN NaN
2013-02-12 27.880 28.00 27.7500 27.88 35990829 MSFT NaN NaN NaN
2013-02-13 27.930 28.11 27.8800 28.03 41715530 MSFT NaN NaN NaN
2013-02-14 27.920 28.06 27.8700 28.04 32663174 MSFT NaN NaN NaN
... ... ... ... ... ... ... ... ... ...
2018-02-01 167.165 168.62 166.7600 167.78 47230787 AAPL 171.948 173.8700 172.8252
2018-02-02 166.000 166.80 160.1000 160.50 86593825 AAPL 170.152 173.2435 172.6356
2018-02-05 159.100 163.88 156.0000 156.49 72738522 AAPL 168.101 172.3180 172.3026
2018-02-06 154.830 163.72 154.0000 163.03 68243838 AAPL 166.700 171.7520 172.0640
2018-02-07 163.085 163.40 159.0685 159.54 51608580 AAPL 165.232 171.0125 171.7554

4752 rows × 9 columns

In [94]:
new_data.columns
Out[94]:
Index(['open', 'high', 'low', 'close', 'volume', 'Name', 'close_10',
       'close_20', 'close_50'],
      dtype='object')
In [102]:
plt.figure(figsize=(20,16))

for index , company in enumerate(tech_list , 1):
    plt.subplot(2 , 2 , index)
    filter1 = new_data['Name']==company
    df = new_data[filter1]
    df[['close_10','close_20', 'close_50']].plot(ax=plt.gca())
    plt.title(company)
In [ ]:
In [ ]:
#ANALYZE CLOSE PRICE CHANGE IN FB STOCK
In [103]:
#With this we can determine gain and loss per stock by comparing opening price to closing price and multiplying the difference
#with the number of shares you own
In [104]:
company_list
Out[104]:
['D:\\\\DA Projects\\\\Stock_Price_Analysis\\\\individual_stocks_5yr\\\\AAPL_data.csv',
 'D:\\\\DA Projects\\\\Stock_Price_Analysis\\\\individual_stocks_5yr\\\\FB_data.csv',
 'D:\\\\DA Projects\\\\Stock_Price_Analysis\\\\individual_stocks_5yr\\\\GOOG_data.csv',
 'D:\\\\DA Projects\\\\Stock_Price_Analysis\\\\individual_stocks_5yr\\\\MSFT_data.csv']
In [105]:
facebook = pd.read_csv(r'D:\\\\DA Projects\\\\Stock_Price_Analysis\\\\individual_stocks_5yr\\\\FB_data.csv')
In [106]:
facebook.head(4)
Out[106]:
date open high low close volume Name
0 2013-02-08 28.89 29.17 28.51 28.5450 37662614 FB
1 2013-02-11 28.61 28.68 28.04 28.2600 36979533 FB
2 2013-02-12 27.67 28.16 27.10 27.3700 93417215 FB
3 2013-02-13 27.36 28.32 27.31 27.9075 50100805 FB
In [107]:
facebook['close']
Out[107]:
0        28.5450
1        28.2600
2        27.3700
3        27.9075
4        28.5000
          ...   
1254    193.0900
1255    190.2800
1256    181.2600
1257    185.3100
1258    180.1800
Name: close, Length: 1259, dtype: float64
In [109]:
facebook['Daily return(in %)'] = facebook['close'].pct_change() * 100

### pct_change() returns : Percentage change between the current and a prior element.
In [110]:
facebook.head(4)
Out[110]:
date open high low close volume Name Daily return(in %)
0 2013-02-08 28.89 29.17 28.51 28.5450 37662614 FB NaN
1 2013-02-11 28.61 28.68 28.04 28.2600 36979533 FB -0.998424
2 2013-02-12 27.67 28.16 27.10 27.3700 93417215 FB -3.149328
3 2013-02-13 27.36 28.32 27.31 27.9075 50100805 FB 1.963829
In [ ]:
In [111]:
import plotly.express as px
In [113]:
px.line(facebook , x="date" , y="Daily return(in %)") ## Plotting Line-plot of "date" vs "Daily return(in %)"..
In [ ]:
In [114]:
#Perform Resampling Analysis
In [ ]:
In [115]:
facebook.dtypes
Out[115]:
date                   object
open                  float64
high                  float64
low                   float64
close                 float64
volume                  int64
Name                   object
Daily return(in %)    float64
dtype: object
In [116]:
facebook['date']=pd.to_datetime(facebook['date'])
In [117]:
facebook.dtypes
Out[117]:
date                  datetime64[ns]
open                         float64
high                         float64
low                          float64
close                        float64
volume                         int64
Name                          object
Daily return(in %)           float64
dtype: object
In [118]:
facebook.head(4)
Out[118]:
date open high low close volume Name Daily return(in %)
0 2013-02-08 28.89 29.17 28.51 28.5450 37662614 FB NaN
1 2013-02-11 28.61 28.68 28.04 28.2600 36979533 FB -0.998424
2 2013-02-12 27.67 28.16 27.10 27.3700 93417215 FB -3.149328
3 2013-02-13 27.36 28.32 27.31 27.9075 50100805 FB 1.963829
In [119]:
facebook.set_index('date' , inplace=True)
In [120]:
facebook.head(4)
Out[120]:
open high low close volume Name Daily return(in %)
date
2013-02-08 28.89 29.17 28.51 28.5450 37662614 FB NaN
2013-02-11 28.61 28.68 28.04 28.2600 36979533 FB -0.998424
2013-02-12 27.67 28.16 27.10 27.3700 93417215 FB -3.149328
2013-02-13 27.36 28.32 27.31 27.9075 50100805 FB 1.963829
In [121]:
facebook['close'].resample('M').mean() ## resample data on monthly basis ..
Out[121]:
date
2013-02-28     27.820536
2013-03-31     26.806075
2013-04-30     26.607864
2013-05-31     26.143114
2013-06-30     23.943700
                 ...    
2017-10-31    173.306818
2017-11-30    179.696667
2017-12-31    177.416500
2018-01-31    184.962857
2018-02-28    186.024000
Freq: M, Name: close, Length: 61, dtype: float64
In [123]:
facebook['close'].resample('M').mean().plot()
Out[123]:
<Axes: xlabel='date'>
In [ ]:
In [124]:
facebook['close'].resample('Y').mean() ## resample data on Yearly basis ..
Out[124]:
date
2013-12-31     36.106290
2014-12-31     68.762178
2015-12-31     88.772540
2016-12-31    117.035079
2017-12-31    156.576175
2018-12-31    185.166923
Freq: A-DEC, Name: close, dtype: float64
In [125]:
facebook['close'].resample('Y').mean().plot()
Out[125]:
<Axes: xlabel='date'>
In [126]:
facebook['close'].resample('Q').mean()
Out[126]:
date
2013-03-31     27.223794
2013-06-30     25.615555
2013-09-30     37.214703
2013-12-31     50.207437
2014-03-31     63.368538
2014-06-30     61.513456
2014-09-30     73.356256
2014-12-31     76.444375
2015-03-31     78.340410
2015-06-30     81.658968
2015-09-30     91.764453
2015-12-31    102.726172
2016-03-31    105.512295
2016-06-30    115.226719
2016-09-30    124.139375
2016-12-31    122.812063
2017-03-31    133.637419
2017-06-30    148.686349
2017-09-30    166.875397
2017-12-31    176.741429
2018-03-31    185.166923
Freq: Q-DEC, Name: close, dtype: float64
In [127]:
facebook['close'].resample('Q').mean().plot()
Out[127]:
<Axes: xlabel='date'>
In [ ]:
In [ ]:
#Analyzing if CLosing prices of The selected stocks are correlated or not
In [128]:
company_list
Out[128]:
['D:\\\\DA Projects\\\\Stock_Price_Analysis\\\\individual_stocks_5yr\\\\AAPL_data.csv',
 'D:\\\\DA Projects\\\\Stock_Price_Analysis\\\\individual_stocks_5yr\\\\FB_data.csv',
 'D:\\\\DA Projects\\\\Stock_Price_Analysis\\\\individual_stocks_5yr\\\\GOOG_data.csv',
 'D:\\\\DA Projects\\\\Stock_Price_Analysis\\\\individual_stocks_5yr\\\\MSFT_data.csv']
In [130]:
company_list[0]
Out[130]:
'D:\\\\DA Projects\\\\Stock_Price_Analysis\\\\individual_stocks_5yr\\\\AAPL_data.csv'
In [131]:
app = pd.read_csv(company_list[0])
faceb = pd.read_csv(company_list[1])
google = pd.read_csv(company_list[2])
msft = pd.read_csv(company_list[3])
In [132]:
closing_price = pd.DataFrame()
In [133]:
closing_price['apple_close'] = app['close']
closing_price['faceb_close'] = faceb['close']
closing_price['goog_close'] = google['close']
closing_price['msft_close'] = msft['close']
In [134]:
closing_price
Out[134]:
apple_close faceb_close goog_close msft_close
0 67.8542 28.5450 558.46 27.55
1 68.5614 28.2600 559.99 27.86
2 66.8428 27.3700 556.97 27.88
3 66.7156 27.9075 567.16 28.03
4 66.6556 28.5000 567.00 28.04
... ... ... ... ...
1254 167.7800 193.0900 NaN 94.26
1255 160.5000 190.2800 NaN 91.78
1256 156.4900 181.2600 NaN 88.00
1257 163.0300 185.3100 NaN 91.33
1258 159.5400 180.1800 NaN 89.61

1259 rows × 4 columns

In [135]:
'''
    Pair-plot is all about , we can considering some pairs & 
    we are trying to plot scatterplot of it..
    
    Unique plots : 4c2 = 6 unique plots
    
    Total plots : 15 ( 6 unique + 6 mirror images of these 
    unique one + 3 diagonal plots(histogram))

'''


# Dis-advantages: 
## Can't be used when number of features are high.
## Cannot visualize higher dimensional patterns in 3-D and 4-D. 
## Only possible to view 2D patterns.



# NOTE: the diagnol elements are (histogram) for each feature.
Out[135]:
'\n    Pair-plot is all about , we can considering some pairs & \n    we are trying to plot scatterplot of it..\n    \n    Unique plots : 4c2 = 6 unique plots\n    \n    Total plots : 15 ( 6 unique + 6 mirror images of these \n    unique one + 3 diagonal plots(histogram))\n\n'
In [ ]:
In [136]:
sns.pairplot(closing_price)
Out[136]:
<seaborn.axisgrid.PairGrid at 0x201beb3f190>
In [ ]:
In [137]:
closing_price.corr()
Out[137]:
apple_close faceb_close goog_close msft_close
apple_close 1.000000 0.896413 0.640522 0.899689
faceb_close 0.896413 1.000000 0.908136 0.969819
goog_close 0.640522 0.908136 1.000000 0.907011
msft_close 0.899689 0.969819 0.907011 1.000000
In [ ]:
In [138]:
#correlation plot for stock prices
In [139]:
sns.heatmap(closing_price.corr() , annot=True)
Out[139]:
<Axes: >
In [1]:
'''Each cell in the heatmap represents the correlation between the closing stock prices of two companies on a given day.

   The correlation coefficient ranges from -1 to 1, with 1 representing a perfect positive correlation, -1 representing 
   a perfect negative correlation, and 0 representing no correlation.

   For example, the cell in the top left corner of the heatmap shows the correlation between Apple's closing stock price 
   and Facebook's closing stock price. The correlation coefficient is 0.9, which means that there is a strong positive 
   correlation between the two stocks. This means that when Apple's stock price goes up, Facebook's stock price also tends
   to go up, and vice versa.

   The other cells in the heatmap can be interpreted in the same way. For example, the cell in the bottom right corner of 
   the heatmap shows the correlation between Microsoft's closing stock price and Google's closing stock price. The correlation 
   coefficient is 0.65, which means that there is a moderate positive correlation between the two stocks.

   Overall, the heatmap shows that the closing stock prices of these four tech companies are all positively correlated to 
   some extent. This means that they tend to move in the same direction, although not always by the same amount.

   Here are some additional things to keep in mind:

  The heatmap only shows the correlation between the closing stock prices of these four companies. It does not show the 
  cause of any correlations.
  
  The correlation between two stocks does not necessarily mean that one stock causes the other to move. It could be that 
  there is a third factor that affects both stocks.
 
  Past performance is not necessarily indicative of future results. Just because these stocks have been correlated in the 
  past does not mean that they will continue to be correlated in the future.'''

---------------------------------------------------------------------------
NameError                                 Traceback (most recent call last)
Cell In[1], line 1
----> 1 company_list

NameError: name 'company_list' is not defined
In [ ]: